CREATE EXTERNAL TABLE `jms_ods.tab_barscan_loading_real_time`( 
   `recordid` string COMMENT '记录编号',                
   `billcode` string COMMENT '运单编号',                
   `listcode` string COMMENT '清单编号',                
   `subbillcode` string COMMENT '子单号',              
   `transfercode` string COMMENT '转单号',             
   `packagecode` string COMMENT '所属袋号',             
   `scantype` string COMMENT '扫描类型',                
   `nextstation` string COMMENT '上一站或下一站',          
   `destination` string COMMENT '目的地点',             
   `scanuser` string COMMENT '扫描雇员',                
   `inputsite` string COMMENT '录入部门',               
   `scantime` timestamp COMMENT '扫描时间',             
   `inputtime` timestamp COMMENT '录入时间',            
   `operatedate` timestamp COMMENT '操作日期',          
   `send_deliver_user` string COMMENT '派件或收件员',     
   `sendcustomer` string COMMENT '寄件客户',            
   `sendsite` string COMMENT '寄件网点',                
   `destsite` string COMMENT '目的网点',                
   `transfercenter` string COMMENT '中转中心',          
   `pcs` bigint COMMENT '件数',                       
   `weight` double COMMENT '重量',                    
   `goodstype` string COMMENT '物品类别',               
   `expresstype` string COMMENT '快件类型',             
   `shifts` string COMMENT '班次',                    
   `transfer_deliver_fee` double COMMENT '中转或派件费',  
   `networkfee` double COMMENT '网管费',               
   `otherfee` double COMMENT '其他费',                 
   `checkflag` string COMMENT '核算标识',               
   `accountflag` bigint COMMENT '对帐标识',             
   `receiptflag` tinyint COMMENT '回单标识',            
   `returnflag` tinyint COMMENT '退件标识',             
   `elescaleflag` string COMMENT '电子秤标识',           
   `unrecordflag` tinyint COMMENT '未录单标识',          
   `writebackflag` bigint COMMENT '回写标识',           
   `lockflag` tinyint COMMENT '锁定标识',               
   `remark` string COMMENT '备注',                    
   `modifyuser` string COMMENT '修改人',               
   `modifytime` timestamp COMMENT '修改时间',           
   `mobile` string COMMENT '手机号码',                  
   `pistolid` string COMMENT '巴枪ID',                
   `remark1` string COMMENT '备注1',                  
   `remark2` string COMMENT '备注2',                  
   `scansitecode` string COMMENT '扫描网点编号',          
   `uploadtime` timestamp COMMENT '上传时间',           
   `remark3` string COMMENT '备注3',                  
   `scanusercode` string COMMENT '扫描雇员编号',          
   `send_deliver_usercode` string COMMENT '收派员编号',  
   `nextstationcode` string COMMENT '上下一站编号',       
   `source` string COMMENT '来源',                    
   `remark5` string COMMENT '备注5',                  
   `remark6` double COMMENT '备注6',                  
   `remark4` string COMMENT '备注4',                  
   `scansiteid` bigint COMMENT '扫描网点ID',            
   `nextstationid` bigint COMMENT '上一站/下一站ID',      
   `scanuserid` bigint COMMENT '扫描雇员ID',            
   `send_deliver_userid` bigint COMMENT '收派员ID',    
   `__delete_sign__` tinyint COMMENT '是否删除：0否，1是',  
   `__op_ts__` timestamp COMMENT '操作时间')            
 COMMENT '装车表'                                      
 PARTITIONED BY (                                   
   `dt` string COMMENT '时间分区')                      
 ROW FORMAT SERDE                                   
   'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe'  
 STORED AS INPUTFORMAT                              
   'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat'  
 OUTPUTFORMAT                                       
   'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' 
 LOCATION                                           
   'hdfs://yl-bg-hdp/dw/hive/jms_ods.db/external/tab_barscan_loading_real_time';